SELECT `t`.`name` `pricetable_name`, `t`.`term_id` `pricetable`, `r`.`id` `resellerid` , `p`.`uri`, `p`.`affiliate_link`, `p`.`uid1`, `p`.`uid2`, `a`.`name` as affiliate_name
					FROM `1clk_7900e82a1908_wp_terms` `t`
					INNER JOIN `1clk_7900e82a1908_wp_afp_prices` `p` ON `p`.`tableid` = `t`.`term_id`
					INNER JOIN `1clk_7900e82a1908_wp_afp_resellers` `r` ON `r`.`id` = `p`.`resellerid`
					INNER JOIN `1clk_7900e82a1908_wp_afp_affiliates` `a` ON `a`.`id` = `r`.`affiliate`
					WHERE CONCAT( `t`.`slug`, '/', `r`.`slug`) = 'siemens-tc86303/coop-dk/{39aa7a8fbf7c34d988a852e330b7c4aeaf98770a83451d1641f0d88fcb8ca51e}7B{39aa7a8fbf7c34d988a852e330b7c4aeaf98770a83451d1641f0d88fcb8ca51e}7B::product.LinkUrl{39aa7a8fbf7c34d988a852e330b7c4aeaf98770a83451d1641f0d88fcb8ca51e}7D{39aa7a8fbf7c34d988a852e330b7c4aeaf98770a83451d1641f0d88fcb8ca51e}7D'